0.0002 |
SELECT * FROM `categories` WHERE `link` = 'surf' AND `active` = 1
|
0.0001 |
SELECT * FROM `categories` WHERE `active` = 1 ORDER BY `sort`
|
0.0001 |
SELECT * FROM products t1 left join( select * from photos t2 where t2.sort=1 ) as t2 on t1.id=t2.product_id WHERE t1.active=1 and t1.category_id=1 group by t1.id order by t1.sort #desc
|