- 26.11.2019
Посуда UNSA
string(869) "SELECT DISTINCT
p.id,
p.url,
p.brand_id,
p.name,
p.annotation,
p.body,
p.position,
p.created as created,
p.visible,
p.featured,
p.meta_title,
p.meta_keywords,
p.meta_description,
p.views,
p.rating,
p.votes,
p.srs_youtube,
p.shops,
b.name as brand,
b.url as brand_url
FROM __products p
LEFT JOIN __images im ON p.id = im.product_id
LEFT JOIN __brands b ON p.brand_id = b.id
INNER JOIN __variants v ON p.id=v.product_id
WHERE
1
AND p.featured=1
AND (SELECT 1 FROM s_images im WHERE im.product_id=p.id LIMIT 1)
AND p.visible=1
ORDER BY null
LIMIT 0, 5 "
Рекомендуемые товары
Новости
- 02.09.2019
- 30.08.2019
- 08.08.2019
- 02.08.2019
В данной категории нет товаров.