select n.id,n.parents,nl.cate_name,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and n.parent=0 and nl.lang="vn" GROUP BY n.id ORDER BY n.orderby asc limit 0,15select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=173 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=177 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=174 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=176 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=794 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=179 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=178 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1602 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=542 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1686 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=432 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=320 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=848 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1291 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=849 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1650 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=937 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=980 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1236 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=855 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2095 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1623 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1757 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1763 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1668 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1624 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1670 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1056 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1627 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1669 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1755 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2352 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1759 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2099 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1067 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2101 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2087 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2258 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2098 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1677 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1915 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1008 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1005 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1015 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1002 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1695 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2156 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2344 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1696 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1004 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1705 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1706 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2155 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2100 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1999 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1294 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1012 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1678 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2527 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2407 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=828 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2160 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2216 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1787 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1735 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2281 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1024 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2218 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2042 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1733 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2210 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2243 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1028 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=480 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2473 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=408 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2037 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2386 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1742 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2038 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2141 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2027 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2115 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2114 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=489 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=791 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=169 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=761 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2123 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=785 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1035 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2119 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1086 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=790 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1680 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1306 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1307 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1322 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1308 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1304 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1309 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1565 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1556 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1310 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=171 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=184 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=595 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1095 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=185 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=596 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1097 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=186 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=951 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1235 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=170 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2526 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=805 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=693 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2044 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2045 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1117 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1144 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1145 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1420 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1884 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1266 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1621 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2002 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2005 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2117 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1162 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2015 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2062 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1993 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=811 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1994 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=700 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1324 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1350 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2070 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2423 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1516 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1616 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1837 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=470 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1894 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1473 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1263 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1264 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1895 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1457 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1953 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1839 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2105 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=2019 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1681 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1293 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1313 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1314 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1407 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1405 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1315 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1312 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=997 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1410 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1397 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=1398 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.cate_hide=1 and nl.lang="vn" and n.parent=998 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and n.parent=0 and nl.lang="vn" GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=173 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=177 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=174 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=176 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=794 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=179 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=178 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1602 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=542 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1686 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=432 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=320 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=848 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1291 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=849 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1650 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=937 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=980 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1236 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=855 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=2095 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1623 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1757 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1763 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1668 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1624 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1670 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1056 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1627 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1669 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1755 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2352 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1759 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2099 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1067 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2101 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2087 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2258 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2098 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=1677 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1915 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1008 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1005 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1015 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1002 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1695 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2156 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2344 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1696 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1004 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1705 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1706 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2155 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2100 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1999 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1294 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1012 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=1678 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2527 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2407 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=828 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2160 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2216 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1787 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1735 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2281 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1024 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2218 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2042 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1733 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2210 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2243 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1028 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=480 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2473 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=408 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2037 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2386 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1742 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2038 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2141 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2027 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2115 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2114 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=489 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=791 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=169 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=761 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2123 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=785 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1035 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2119 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1086 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=790 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=1680 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1306 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1307 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1322 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1308 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1304 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1309 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1565 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1556 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1310 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=171 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=184 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=595 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1095 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=185 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=596 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1097 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=186 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=951 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1235 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=170 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2526 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=805 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=693 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2044 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2045 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1117 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1144 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1145 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1420 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1884 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1266 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1621 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2002 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2005 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2117 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1162 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=2015 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2062 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1993 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=811 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1994 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=700 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1324 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1350 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2070 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2423 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1516 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1616 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1837 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=470 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=1894 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1473 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1263 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1264 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1895 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1457 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1953 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1839 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2105 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2019 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=1681 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1293 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1313 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1314 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1407 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1405 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1315 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1312 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=997 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1410 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1397 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1398 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=998 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.parents,nl.cate_name,nl.cate_slug,qc.Anh,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id left join quangcao qc on n.id=qc.ViTri where 1 and nl.lang="vn" and n.parent=1748 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1664 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1363 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1366 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1749 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=503 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1030 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1750 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1367 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1039 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1793 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1800 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1921 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1747 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1991 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=2223 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1791 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1792 GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.parents,nl.cate_slug,n.cate_thumb,n.cate_thumb_large from `categories` n join cate_lang nl on n.id = nl.cate_id where 1 and nl.lang="vn" and n.parent=1753 GROUP BY n.id ORDER BY n.orderby asc select n.id,n.brand_thumb,nl.brand_name,nl.brand_slug from `brand` n join brand_lang nl on n.id = nl.brand_id left join product p on p.product_brand = n.id where 1 and nl.lang ="vn" and n.brand_index=1 GROUP BY n.id ORDER BY n.brand_orderby asc limit 0,14select n.id,n.video_name,n.video_thumb,n.video_update from `video` n where 1 and n.video_index=1 and n.video_hide =1 GROUP BY n.id ORDER BY n.id desc limit 0,4select n.id,n.catalog_name,n.catalog_thumb,n.catalog_file,n.catalog_update from `catalog` n where 1 and n.catalog_index=1 and n.catalog_hide =1 GROUP BY n.id ORDER BY n.id desc limit 0,4select n.id,nl.cate_name,n.cate_hide,n.orderby from `cate_news` n join news_cate_lang nl on n.id = nl.cate_id where 1 and n.parent=0 and n.type=1 and nl.lang="vn" GROUP BY n.id ORDER BY n.cate_hide desc,n.orderby asc limit 0,10select n.id,nl.cate_name,n.cate_hide,n.orderby from `cate_news` n join news_cate_lang nl on n.id = nl.cate_id where 1 and n.parent=0 and n.type=2 and nl.lang="vn" GROUP BY n.id ORDER BY n.cate_hide desc,n.orderby asc limit 0,1select n.id,nl.news_name,n.news_status from `news` n join news_lang nl on n.id = nl.news_id where 1 and n.news_hide=1 and n.parent=1 and nl.lang="vn" GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.news_name,n.news_status from `news` n join news_lang nl on n.id = nl.news_id where 1 and n.news_hide=1 and n.parent=2 and nl.lang="vn" GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.news_name,n.news_status from `news` n join news_lang nl on n.id = nl.news_id where 1 and n.news_hide=1 and n.parent=3 and nl.lang="vn" GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.news_name,n.news_status from `news` n join news_lang nl on n.id = nl.news_id where 1 and n.news_hide=1 and n.parent=4 and nl.lang="vn" GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,nl.cate_slug from `cate_news` n join news_cate_lang nl on n.id = nl.cate_id where 1 and n.parent=0 and n.type=3 and nl.lang="vn" GROUP BY n.id ORDER BY n.cate_hide desc,n.orderby asc limit 0,1select n.id,nl.news_name,n.news_status from `news` n join news_lang nl on n.id = nl.news_id where 1 and n.news_hide=1 and n.parent=6 and nl.lang="vn" GROUP BY n.id ORDER BY n.orderby asc select n.id,nl.cate_name,n.cate_hide,n.orderby from `cate_news` n join news_cate_lang nl on n.id = nl.cate_id where 1 and n.parent=0 and n.type=4 and nl.lang="vn" GROUP BY n.id ORDER BY n.cate_hide desc , n.orderby asc limit 0,1select n.id,nl.news_name,n.news_thumb,n.news_status,n.news_create,n.news_update from `news` n join news_lang nl on n.id = nl.news_id where 1 and n.news_index=1 and n.news_hide=1 and n.parent=7 and nl.lang="vn" GROUP BY n.id ORDER BY n.orderby asc,n.id desc limit 0,4select n.id,n.news_name,n.news_thumb,n.news_update from `news1` n where 1 and n.news_event_index=1 and n.news_hide=1 GROUP BY n.id ORDER BY n.id desc limit 0,4select n.id,n.cate_name,n.cate_hide,n.orderby from `cate_news1` n where 1 and n.cate_hide=1 GROUP BY n.id ORDER BY n.orderby asc,n.id desc select n.id,nl.name,nl.link,n.orderby from `link` n join link_lang nl on n.id = nl.link_id where 1 and nl.lang="vn" and n.parent=0 and n.link_hide=1 GROUP BY n.id ORDER BY n.orderby asc select k.NguoiLienHe from `tbl_user` n left join customer_detail_online k on k.ID_User = n.id where 1 and k.ID_User="" GROUP BY n.id ORDER BY k.ID desc select nl.*,n.brand_thumb from `brand` n left join brand_lang nl on n.id = nl.brand_id where 1 and nl.lang="vn" and nl.brand_slug= "sino" GROUP BY n.id limit 0,1select n.id,nl.menu_name,n.parent from `menu_brand` n left join menu_brand_lang nl on n.id = nl.menu_brand_id where 1 and nl.lang="vn" and n.menu_brand=652 GROUP BY n.id ORDER BY n.orderby asc select n.*,nla.parent,nla.parents from `cate_lang` n join product nl on n.cate_id = nl.product_cate join categories nla on nla.id = n.cate_id where 1 and n.lang= "vn" and nl.product_brand=652 GROUP BY n.id ORDER BY nla.orderby asc select n.*,nla.parent,nla.parents from `cate_lang` n join categories nla on nla.id = n.cate_id where 1 and n.lang= "vn" and nla.id in (1015,1695,1915,1677,1002,2498,1915,1002,1677,2498,1677,1002,1915,1677,2095,1915,1677,1015,174,1677,1677,1915,2095,1005,1012,1677,2499,1677,1015) GROUP BY nla.parent ORDER BY nla.orderby asc select sum(dh.SL) + n.product_old_quantity_by as sum,n.id,nl.product_unit,nl.product_thumb,n.product_code,n.product_model1,n.product_model2,n.product_model3,n.product_price,nl.product_name,n.product_code,bl.brand_name, n.product_view from `product` n join product_lang nl on n.id = nl.product_id join brand_lang bl on nl.product_brand = bl.id join tbl_donhang dh on dh.ID_DH = n.id where 1 and dh.Buoc >= 7 and dh.TrangThai_DonHang = 4 and n.product_vn=1 and n.product_hide =1 and nl.lang ="vn" and n.product_brand in(652) GROUP BY dh.ID_DH ORDER BY sum desc,n.id desc limit 0,20select n.id,nl.product_unit,nl.product_thumb,n.product_code,n.product_model1,n.product_model2,n.product_model3,n.product_price,nl.product_name,n.product_code,bl.brand_name, n.product_view from `product` n join product_lang nl on n.id = nl.product_id join brand_lang bl on nl.product_brand = bl.id join tbl_donhang dh on dh.ID_DH = n.id where 1 and n.product_vn=1 and n.product_hide =1 and nl.lang ="vn" and n.product_brand in(652) GROUP BY n.id ORDER BY n.product_update desc limit 0,10
652
vn
Array
(
    [0] => Array
        (
            [id] => 52280
            [product_unit] => Cái
            [product_thumb] => image/vn/2021_04/hat-cong-tac-10a-220v-s18-sino-1617936160.jpg
            [product_code] => S18
            [product_model1] => 
            [product_model2] => 
            [product_model3] => 
            [product_price] => 0
            [product_name] => Hạt công tắc 10A 220V
            [brand_name] => SINO
            [product_view] => 138
        )

    [1] => Array
        (
            [id] => 52279
            [product_unit] => Cái
            [product_thumb] => image/vn/2021_04/o-cam-da-nang-co-man-che-voi-1-lo-s18uamx-sino-1617934319.jpg
            [product_code] => S18UAMX
            [product_model1] => 
            [product_model2] => 
            [product_model3] => 
            [product_price] => 0
            [product_name] => Ổ cắm đa năng có màn che với 1 lỗ 
            [brand_name] => SINO
            [product_view] => 131
        )

    [2] => Array
        (
            [id] => 20430
            [product_unit] => Cái
            [product_thumb] => image/vn/2017_05/de-noi-tgcn-20430-sino_1495681088_vn.jpg
            [product_code] => TGCN-20430
            [product_model1] => 
            [product_model2] => 
            [product_model3] => 
            [product_price] => 0
            [product_name] => Đế nổi đơn
            [brand_name] => SINO
            [product_view] => 1303
        )

    [3] => Array
        (
            [id] => 31281
            [product_unit] => Cuộn
            [product_thumb] => image/vn/2017_11/ruot-ga-phi-20-sino_1511842135_vn.jpg
            [product_code] => SP9020CM
            [product_model1] => 
            [product_model2] => 
            [product_model3] => 
            [product_price] => 0
            [product_name] => Ống ruột gà luồn dây điện, loại gen mềm chống cháy phi 20 
            [brand_name] => SINO
            [product_view] => 2910
        )

    [4] => Array
        (
            [id] => 20668
            [product_unit] => Cuộn
            [product_thumb] => image/vn/2017_05/ong-ruot-ga-luon-day-dien-phi-32-tgck-vietnam_1496201902_vn.jpg
            [product_code] => SP9032CM
            [product_model1] => 
            [product_model2] => 
            [product_model3] => 
            [product_price] => 0
            [product_name] => Ống ruột gà luồn dây điện phi 32
            [brand_name] => SINO
            [product_view] => 1845
        )

    [5] => Array
        (
            [id] => 50892
            [product_unit] => Cái
            [product_thumb] => image/vn/2020_09/kep-do-ong-phi-20-e28020-sino-1598955617.jpg
            [product_code] => E280/20
            [product_model1] => 
            [product_model2] => 
            [product_model3] => 
            [product_price] => 0
            [product_name] => Kẹp đỡ ống phi 20
            [brand_name] => SINO
            [product_view] => 598
        )

    [6] => Array
        (
            [id] => 49645
            [product_unit] => Cái
            [product_thumb] => image/vn/2020_05/cut-chu-l-khong-nap-phi-20-e24420s-sino-1590464365.png
            [product_code] => E244/20S
            [product_model1] => 
            [product_model2] => 
            [product_model3] => 
            [product_price] => 0
            [product_name] => Cút chữ L không nắp phi 20
            [brand_name] => SINO
            [product_view] => 473
        )

    [7] => Array
        (
            [id] => 49644
            [product_unit] => Cái
            [product_thumb] => image/vn/2020_05/khop-noi-tron-20mm-e24220-sino-1590464126.PNG
            [product_code] => E242/20
            [product_model1] => 
            [product_model2] => 
            [product_model3] => 
            [product_price] => 0
            [product_name] => Khớp nối trơn 20mm
            [brand_name] => SINO
            [product_view] => 517
        )

    [8] => Array
        (
            [id] => 49643
            [product_unit] => Gói
            [product_thumb] => image/vn/2020_05/dau-van-rang-dung-cho-ong-phi-25-e24220-sino-1590463808.PNG
            [product_code] => E281/25
            [product_model1] => 
            [product_model2] => 
            [product_model3] => 
            [product_price] => 0
            [product_name] => Đầu vặn răng dùng cho ống phi 25
            [brand_name] => SINO
            [product_view] => 497
        )

    [9] => Array
        (
            [id] => 49641
            [product_unit] => Gói
            [product_thumb] => image/vn/2020_05/kep-do-ong-phi-25-e28025-sino-1590462538.PNG
            [product_code] => E280/25
            [product_model1] => 
            [product_model2] => 
            [product_model3] => 
            [product_price] => 0
            [product_name] => Kẹp đỡ ống phi 25
            [brand_name] => SINO
            [product_view] => 565
        )

)