druk: select c.categories_id, c.categories_image, cd.categories_link, cd.categories_name, cd.dane_szukaj,
IF ((cd.dane_szukaj) REGEXP ('[-/\_ ]dt to 412s b412 3k[-/\_ ]'),1000,0) +
IF ((cd.dane_szukaj) REGEXP ('[-/\_ ]dt[-/\_ ]to[-/\_ ]412[-/\_ ]s[-/\_ ]b[-/\_ ]412[-/\_ ]3[-/\_ ]k[-/\_ ]'),500,0) +
IF ((cd.dane_szukaj) REGEXP ('[-/\_ ]dt to 412s b412 3k'),250,0) +
IF ((cd.dane_szukaj) REGEXP ('[-/\_ ]dt[-/\_ ]to[-/\_ ]412[-/\_ ]s[-/\_ ]b[-/\_ ]412[-/\_ ]3[-/\_ ]k'),150,0) +
IF ((cd.categories_name_short) REGEXP ('dt to 412s b412 3k'),300,0) +
IF ((cd.dane_szukaj) REGEXP ('dt to 412s b412 3k'),150,0) +
IF ((cd.dane_szukaj) REGEXP ('dt[-/\_ ]to[-/\_ ]412[-/\_ ]s[-/\_ ]b[-/\_ ]412[-/\_ ]3[-/\_ ]k'),100,0) + ROUND(c.popularnosc/10) + IF ((cd.dane_szukaj) REGEXP ('dt'),114,0) + IF ((cd.dane_szukaj) REGEXP ('to'),114,0) + IF ((cd.dane_szukaj) REGEXP ('[^0-9]412[a-z \-/\]$'),42,0) + IF ((cd.dane_szukaj) REGEXP ('[^0-9]412'),42,0) + IF ((cd.dane_szukaj) REGEXP ('412'),171,0) + IF ((cd.dane_szukaj) REGEXP ('[^0-9]412s[a-z \-/\]$'),42,0) + IF ((cd.dane_szukaj) REGEXP ('[^0-9]412s'),42,0) + IF ((cd.dane_szukaj) REGEXP ('412s'),171,0) + IF ((cd.dane_szukaj) REGEXP ('[^0-9]b412[a-z \-/\]$'),42,0) + IF ((cd.dane_szukaj) REGEXP ('[^0-9]b412'),42,0) + IF ((cd.dane_szukaj) REGEXP ('b412'),171,0) + IF ((cd.dane_szukaj) REGEXP ('[^0-9]3k[a-z \-/\]$'),14,0) + IF ((cd.dane_szukaj) REGEXP ('[^0-9]3k'),14,0) + IF ((cd.dane_szukaj) REGEXP ('3k'),57,0) + 600 as wynik
from categories as c
LEFT JOIN categories_description as cd on cd.categories_id = c.categories_id
where c.categories_status = '1' and c.id_seria > 0 and ((c.categories_id like "2%")) and (
(cd.dane_szukaj) REGEXP ('dt[-/\\_ ]to[-/\\_ ]412[-/\\_ ]s[-/\\_ ]b[-/\\_ ]412[-/\\_ ]3[-/\\_ ]k') or (cd.dane_szukaj) REGEXP ('dt') or (cd.dane_szukaj) REGEXP ('to') or (cd.dane_szukaj) REGEXP ('412') or (cd.dane_szukaj) REGEXP ('412s') or (cd.dane_szukaj) REGEXP ('b412') or (cd.dane_szukaj) REGEXP ('3k') ) group by c.categories_id having wynik > 999
order by wynik desc, c.popularnosc desc
LIMIT 100
all: select DISTINCT p.products_id, ocena_avg, r.ocena_count, p.products_image, p.products_quantity, pd.products_description, p.manufacturers_id, p.manufacturers_id_dedykowany, p.products_model, p.products_availability_id, p.polecany, p.darmowa_wysylka, p.waga, p.pojemnosc, p.wydajnosc, p.kategoria, p.technologia, p.rodzaj, p.typ, p.kolor, p.lplm, p.ilosc, pd.products_link, pd.products_name, p.products_price, p.products_retail_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, s.status, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, CONCAT_WS('/', pf.kategoria, pf.technologia, pf.typ, pf.rodzaj) as kategoria_impression , '0' as wykorzystaj_kupon, pfe.kod_konekt ,
IF ((pd.products_szukaj) REGEXP ('[-/\_ ]dt to 412s b412 3k[-/\_ ]'),1000,0) +
IF ((pd.products_szukaj) REGEXP ('[-/\_ ]dt[-/\_ ]to[-/\_ ]412[-/\_ ]s[-/\_ ]b[-/\_ ]412[-/\_ ]3[-/\_ ]k[-/\_ ]'),500,0) +
IF ((pd.products_szukaj) REGEXP ('[-/\_ ]dt to 412s b412 3k'),250,0) +
IF ((pd.products_szukaj) REGEXP ('[-/\_ ]dt[-/\_ ]to[-/\_ ]412[-/\_ ]s[-/\_ ]b[-/\_ ]412[-/\_ ]3[-/\_ ]k'),150,0) +
IF ((pd.products_szukaj) REGEXP ('dt to 412s b412 3k'),150,0) +
IF ((pd.products_szukaj) REGEXP ('dt[-/\_ ]to[-/\_ ]412[-/\_ ]s[-/\_ ]b[-/\_ ]412[-/\_ ]3[-/\_ ]k'),100,0) + ROUND(p.popularnosc/10) + 600+ IF ((pd.products_szukaj) REGEXP ('dt'),114,0) + IF ((pd.products_szukaj) REGEXP ('to'),114,0) + IF ((pd.products_szukaj) REGEXP ('[^0-9]412[a-z \-/\]$'),42,0) + IF ((pd.products_szukaj) REGEXP ('[^0-9]412'),42,0) + IF ((pd.products_szukaj) REGEXP ('412'),171,0) + IF ((pd.products_szukaj) REGEXP ('[^0-9]412s[a-z \-/\]$'),42,0) + IF ((pd.products_szukaj) REGEXP ('[^0-9]412s'),42,0) + IF ((pd.products_szukaj) REGEXP ('412s'),171,0) + IF ((pd.products_szukaj) REGEXP ('[^0-9]b412[a-z \-/\]$'),42,0) + IF ((pd.products_szukaj) REGEXP ('[^0-9]b412'),42,0) + IF ((pd.products_szukaj) REGEXP ('b412'),171,0) + IF ((pd.products_szukaj) REGEXP ('[^0-9]3k[a-z \-/\]$'),14,0) + IF ((pd.products_szukaj) REGEXP ('[^0-9]3k'),14,0) + IF ((pd.products_szukaj) REGEXP ('3k'),57,0)
+ IF(p.kategoria = 1 and p.typ=1,55,0)
+ IF(p.kategoria = 1 and p.typ=2,50,0)
+ IF(p.kategoria = 1 and p.typ=5,52,0)
+ IF(p.manufacturers_id = 1,100,0) + IF(p.products_quantity > 1,10,0) as wynik from (((products p LEFT JOIN products_filtrowanie as pf on pf.kategoria_id = p.kategoria and pf.technologia_id = p.technologia and pf.rodzaj_id = p.rodzaj and pf.typ_id = p.typ and pf.lplm = '2' and pf.language_id = '1') left join manufacturers m using(manufacturers_id), products_description pd) left join manufacturers md on p.manufacturers_id_dedykowany = md.manufacturers_id left join specials s on p.products_id = s.products_id
left join (select products_id, count(*) as ocena_count, avg(ocena) as ocena_avg from reviews where approved = 1 GROUP BY products_id) r on r.products_id = p.products_id
left join (select pfe.products_id, GROUP_CONCAT(kod_konekt) as kod_konekt from products_feature pfe GROUP BY pfe.products_id) as pfe on pfe.products_id = p.products_id
) where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '2' and ((pd.products_szukaj) REGEXP ('dt[-/\\_ ]to[-/\\_ ]412[-/\\_ ]s[-/\\_ ]b[-/\\_ ]412[-/\\_ ]3[-/\\_ ]k') or (pd.products_szukaj) REGEXP ('dt') or (pd.products_szukaj) REGEXP ('to') or (pd.products_szukaj) REGEXP ('412') or (pd.products_szukaj) REGEXP ('412s') or (pd.products_szukaj) REGEXP ('b412') or (pd.products_szukaj) REGEXP ('3k') ) and p.kategoria in(1) and p.technologia in(2) group by p.products_id having wynik > 570.33333333333 and wynik > 500 order by wynik desc, products_availability_id, p.popularnosc desc, pd.products_name
Array
(
[0] => dt
[1] => to
[2] => 412
[3] => 412s
[4] => b412
[5] => 3k
)
1
| Language Information Newsletter Contact |
|