BOUTIQUE ONLINE

SELECT sys_product_category.page_code category_page_code,online_buy_enabled,quantity_available,sys_product.page_code,vat,starting_quantity,growing_quantity,sys_product.id,sys_product.label,sys_product.image,sys_product.price,sys_product.discount,sys_product.category_id,sys_product_category.label category_label,rating,sys_product.evidence_flag, badge_text,sys_product.evidence_id,if(sys_product.created_at > now() - interval 30 day,1,0)f_new FROM `sys_product` join sys_product_category on (sys_product_category.id = sys_product.category_id) left join sys_site_tags on (sys_site_tags.id = sys_product.evidence_id) where sys_product.status = 'on-line' and sys_product.`created_by`=3103 and sys_product.evidence_flag = 1 and sys_product.evidence_id = 27 order by sys_product.order_view ,sys_product.created_at desc limit 12