SELECT DISTINCT m1.id, m1.url, m1.first_page, m2.make_name, m2.descr, ic.cnt as totprods
FROM dst_cat_sectitem c1
INNER JOIN dst_cat_item i1 ON c1.item_id=i1.id AND i1.archive=0
INNER JOIN dst_cat_producer m1 ON i1.make_id=m1.id
INNER JOIN dst_cat_producer_lang m2 ON m1.id=m2.make_id AND m2.lang_id='2'
LEFT JOIN dst_cat_item_count_cache ic ON ic.sect_id = c1.sect_id AND ic.make_id = m1.id AND ic.car_id = 0
WHERE c1.sect_id='1'
ORDER BY m2.make_name Disk full (/var/tmp/#sql_11bb_4); waiting for someone to free some space...SELECT DISTINCT p1.url as make_url, i1.*, i2.model2, i2.descr, i2.descr0, m1.make_name as producer, cc1.name as section,
max(pr1.price) as maxcost, min(pr1.price) as mincost, max(pr1.availiable_now) as sortexist,
case when max(pr1.price)=0 then 1 else 0 end as sortcost, cc1.sect_id as sectid
FROM dst_cat_item i1
INNER JOIN dst_cat_item_lang i2 ON i1.id=i2.item_id AND i2.lang_id='2'
INNER JOIN dst_cat_sectitem c1 ON i1.id=c1.item_id AND c1.sect_id='1'
INNER JOIN dst_cat_producer_lang m1 ON ( (i1.make_id=16) OR (i1.make_id=8) OR (i1.make_id=10) OR (i1.make_id=18) ) AND i1.make_id=m1.make_id AND m1.lang_id='2'
INNER JOIN dst_cat_producer p1 ON p1.id=m1.make_id
INNER JOIN dst_cat_section_lang cc1 ON c1.sect_id=cc1.sect_id AND cc1.lang_id='2'
LEFT JOIN dst_cat_price pr1 ON i1.id=pr1.item_id
INNER JOIN dst_cat_filters_value v0 ON i1.id=v0.item_id AND v0.param_id=6 AND v0.value='21' INNER JOIN dst_cat_filters_value v1 ON i1.id=v1.item_id AND v1.param_id=8 AND v1.value=0 INNER JOIN dst_cat_filters_valueopts owi1 ON v1.id=owi1.param_value_id AND owi1.option_id IN (52,56)
WHERE i1.archive=0
GROUP BY i1.id
ORDER BY sortexist DESC, sortcost, item_rate DESC
LIMIT 0,24Disk full (/var/tmp/#sql_11bb_4); waiting for someone to free some space...
Чоловіче взуття Caterpillar, Vans, Native, Skechers – інтернет магазин District
