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=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=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=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=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=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=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=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=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=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=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=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=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=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=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=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=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=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=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=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=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=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=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=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=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 n.id,nl.product_unit,nl.product_thumb,n.product_code,product_model1,n.product_model2,n.product_model3,n.product_price,nl.product_name,nl.product_name1,nl.product_name2,bl.brand_name from `product` n join product_lang nl on n.id = nl.product_id left join brand_lang bl on nl.product_brand = bl.id where 1 and n.product_vn=1 and n.product_hide =1 and nl.lang ='vn' and nl.product_alias LIKE '%sm-5%' GROUP BY n.id ORDER BY n.id desc limit 0,10 sm-5