 |
Kategorie |
 |
|
|
Informacje |
|
|
|
Kontakt |
|
|
|
Opinie |
|
|
|
 |
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select distinct p.products_image,p.products_image1,p.products_image_m, m.manufa' at line 1
select count(distinct p.products_id) as total select distinct p.products_image,p.products_image1,p.products_image_m, m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, opis_alarm_1, opis_alarm_2, opis_datownik_1, opis_datownik_2, opis_kolor_koperty, opis_kolor_paska, opis_koperta_1, opis_koperta_2, opis_mechanizm_1, opis_mechanizm_2, opis_pasek_1 , opis_pasek_2, opis_podswietlenie_1, opis_stoper_1, opis_stoper_2, opis_szkielko_1, opis_szkielko_2, opis_tarcza_1, opis_tarcza_2, opis_timer_1, opis_timer_2, opis_wodoszczelnosc_1, opis_wodoszczelnosc_2, szerokosc_koperty, grubosc_koperty, zywotnosc_baterii, chronograffrom products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id inner join opis_funkcje on p.products_id=opis_funkcje.products_id
inner join opis_atrybuty on p.products_id=opis_atrybuty.products_id
inner join opis_stoper on opis_atrybuty.opis_stoper_id=opis_stoper.opis_stoper_id
inner join opis_alarm on opis_atrybuty.opis_alarm_id=opis_alarm.opis_alarm_id
inner join opis_datownik on opis_atrybuty.opis_datownik_id=opis_datownik.opis_datownik_id
inner join opis_kolor_koperty on opis_atrybuty.opis_kolor_koperty_id=opis_kolor_koperty.opis_kolor_koperty_id
inner join opis_kolor_paska on opis_atrybuty.opis_kolor_paska_id=opis_kolor_paska.opis_kolor_paska_id
inner join opis_koperta on opis_atrybuty.opis_koperta_id=opis_koperta.opis_koperta_id
inner join opis_mechanizm on opis_atrybuty.opis_mechanizm_id=opis_mechanizm.opis_mechanizm_id
inner join opis_pasek on opis_atrybuty.opis_pasek_id=opis_pasek.opis_pasek_id
inner join opis_podswietlenie on opis_atrybuty.opis_podswietlenie_id=opis_podswietlenie.opis_podswietlenie_id
inner join opis_szkielko on opis_atrybuty.opis_szkielko_id=opis_szkielko.opis_szkielko_id
inner join opis_tarcza on opis_atrybuty.opis_tarcza_id=opis_tarcza.opis_tarcza_id
inner join opis_timer on opis_atrybuty.opis_timer_id=opis_timer.opis_timer_id
inner join opis_wodoszczelnosc on opis_atrybuty.opis_wodoszczelnosc_id=opis_wodoszczelnosc.opis_wodoszczelnosc_id
, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id<>731 and p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and (p2c.categories_id = '153' or p2c.categories_id = '177' or p2c.categories_id = '179' or p2c.categories_id = '191' or p2c.categories_id = '269' or p2c.categories_id = '270' or p2c.categories_id = '271' or p2c.categories_id = '272' or p2c.categories_id = '278' or p2c.categories_id = '279' or p2c.categories_id = '280' or p2c.categories_id = '281' or p2c.categories_id = '301' or p2c.categories_id = '302') and ((pd.products_name like '%illuminator%' or p.products_model like '%illuminator%' or m.manufacturers_name like '%illuminator%'
or pd.products_description like '%illuminator%'
or opis_alarm_1 like '%illuminator%'
or opis_alarm_2 like '%illuminator%'
or opis_datownik_1 like '%illuminator%'
or opis_datownik_2 like '%illuminator%'
or opis_kolor_koperty like '%illuminator%'
or opis_kolor_paska like '%illuminator%'
or opis_koperta_1 like '%illuminator%'
or opis_koperta_2 like '%illuminator%'
or opis_mechanizm_1 like '%illuminator%'
or opis_mechanizm_2 like '%illuminator%'
or opis_pasek_1 like '%illuminator%'
or opis_pasek_2 like '%illuminator%'
or opis_podswietlenie_1 like '%illuminator%'
or opis_stoper_1 like '%illuminator%'
or opis_stoper_2 like '%illuminator%'
or opis_szkielko_1 like '%illuminator%'
or opis_szkielko_2 like '%illuminator%'
or opis_tarcza_1 like '%illuminator%'
or opis_tarcza_2 like '%illuminator%'
or opis_timer_1 like '%illuminator%'
or opis_timer_2 like '%illuminator%'
or opis_wodoszczelnosc_1 like '%illuminator%'
or opis_wodoszczelnosc_2 like '%illuminator%'
) )
[TEP STOP]
| |
