Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $topSql ='(SELECT i.id,i.id_group_0,i.id_group_1,i.img_w_h,i.svoistva,i.id_item,i.url,i.name,
- i.col_29,pr.price as `fprice`,i.price,
- ip.`ext_small_picture`,ip.`ext_picture`
- FROM `items` as i
- LEFT JOIN `items_props` as ip ON ip.id_external = i.id_item
- LEFT JOIN `items_prices` as pr on pr.idItem = i.id_item AND pr.idFilial = ' . $_SESSION['idFilial'] . '
- INNER JOIN `items_store`as s on s.idItem = i.id_item AND s.idFilial = ' . $_SESSION['idFilial'].'
- WHERE i.col_29 = 1 AND i.`id_item`!= \'\' AND i.`id_item` IS NOT NULL AND i.`on_off` = 1
- ) UNION';
- $bestSql = '(SELECT i.id,i.id_group_0,i.id_group_1,i.img_w_h,i.svoistva,i.id_item,i.url,i.name,
- i.col_29,pr.price as `fprice`,i.price,
- ip.`ext_small_picture`,ip.`ext_picture`
- FROM `items` as i
- LEFT JOIN `items_props` as ip ON ip.id_external = i.id_item
- LEFT JOIN `items_prices` as pr on pr.idItem = i.id_item AND pr.idFilial = ' . $_SESSION['idFilial'] . '
- INNER JOIN `items_store`as s on s.idItem = i.id_item AND s.idFilial = ' . $_SESSION['idFilial'].'
- WHERE `id_item`!="" AND `id_item` IS NOT NULL AND (ip.`ext_small_picture` != "" OR ip.ext_picture != "")
- AND `id_group_0` NOT IN("' . implode('","', $ids) . '")) UNION';
- foreach ($this->store as $store) {
- if($store == !$_SESSION['idFilial']){
- $topSql .=' (SELECT i.id,i.id_group_0,i.id_group_1,i.img_w_h,i.svoistva,i.id_item,i.url,i.name,
- i.col_29,pr.price as `fprice`,i.price,
- ip.`ext_small_picture`,ip.`ext_picture`
- FROM `items` as i
- LEFT JOIN `items_props` as ip ON ip.id_external = i.id_item
- LEFT JOIN `items_prices` as pr on pr.idItem = i.id_item AND pr.idFilial = ' . $_SESSION['idFilial'] . '
- INNER JOIN `items_store`as s on s.idItem = i.id_item AND s.idFilial = ' . $store.'
- WHERE i.col_29 = 1 AND i.`id_item`!= \'\' AND i.`id_item` IS NOT NULL AND i.`on_off` = 1
- ) UNION';
- $bestSql .= '(SELECT i.id,i.id_group_0,i.id_group_1,i.img_w_h,i.svoistva,i.id_item,i.url,i.name,
- i.col_29,pr.price as `fprice`,i.price,
- ip.`ext_small_picture`,ip.`ext_picture`
- FROM `items` as i
- LEFT JOIN `items_props` as ip ON ip.id_external = i.id_item
- LEFT JOIN `items_prices` as pr on pr.idItem = i.id_item AND pr.idFilial = ' . $_SESSION['idFilial'] . '
- INNER JOIN `items_store`as s on s.idItem = i.id_item AND s.idFilial = ' . $_SESSION['idFilial'].'
- WHERE `id_item`!="" AND `id_item` IS NOT NULL AND (ip.`ext_small_picture` != "" OR ip.ext_picture != "")
- AND `id_group_0` NOT IN("' . implode('","', $ids) . '")) UNION';
- }
- }
- $topSql = rtrim($topSql,'UNION');
- $newSql = rtrim($bestSql,'UNION').' ORDER BY `id` DESC LIMIT 100';
- $bestSql = rtrim($bestSql,'UNION').' ORDER BY `rating` DESC LIMIT 100';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement