|
query - SELECT prod.pr_name,prod.pr_description, prod.pr_id as pr_id, prod.ca_id, prod.pr_image, prod.pr_priority,prod.pr_active, cat.ca_name FROM gs_product as prod, gs_categories as cat WHERE cat.ca_id = prod.ca_id and prod.pr_active='Y' AND find_in_set(47,prod.ca_id) AND prod.pr_login < '3' AND prod.us_id='0' ORDER BY prod.pr_priority, prod.pr_name ASC
|
|
