Query: SHOW FULL COLUMNS FROM `clients`

Query: SHOW FULL COLUMNS FROM `clients`

Query: SHOW FULL COLUMNS FROM `clients`

Query: SHOW FULL COLUMNS FROM `clients`

Query: SHOW FULL COLUMNS FROM `news`

Query: SHOW FULL COLUMNS FROM `news`

Query: SHOW FULL COLUMNS FROM `news`

Query: SHOW FULL COLUMNS FROM `news`

Query: SHOW FULL COLUMNS FROM `brands_models`

Query: SHOW FULL COLUMNS FROM `brands_models`

Query: SHOW FULL COLUMNS FROM `brands_models`

Query: SHOW FULL COLUMNS FROM `brands_models`

Query: SHOW FULL COLUMNS FROM `brands_models_details`

Query: SHOW FULL COLUMNS FROM `brands_models_details`

Query: SHOW FULL COLUMNS FROM `brands_models_details`

Query: SHOW FULL COLUMNS FROM `brands_models_details`

Query: SHOW FULL COLUMNS FROM `brands_models_equipment`

Query: SHOW FULL COLUMNS FROM `brands_models_equipment`

Query: SHOW FULL COLUMNS FROM `brands_models_equipment`

Query: SHOW FULL COLUMNS FROM `brands_models_equipment`

Query: SHOW FULL COLUMNS FROM `representatives`

Query: SHOW FULL COLUMNS FROM `representatives`

Query: SHOW FULL COLUMNS FROM `representatives`

Query: SHOW FULL COLUMNS FROM `representatives`

Query: SHOW FULL COLUMNS FROM `citys`

Query: SHOW FULL COLUMNS FROM `citys`

Query: SHOW FULL COLUMNS FROM `citys`

Query: SHOW FULL COLUMNS FROM `citys`

Query: SHOW FULL COLUMNS FROM `regions`

Query: SHOW FULL COLUMNS FROM `regions`

Query: SHOW FULL COLUMNS FROM `regions`

Query: SHOW FULL COLUMNS FROM `regions`

Query: SELECT documents_files.priority AS my_priority, MAX(documents_files.priority) AS super_priority, documents.document_id, documents.has_main_thumb, documents.hash_thumb, documents.title, documents.description_short, documents.description_long, documents.notes, documents.active_web_to, documents.created, documents.active_web_from, documents.file_category_id, brands_models.model_id, documents.models, documents.representatives, documents.car_services_options, documents_files.description, documents_files.hash, documents_files.url, documents_files.document_file_id, brands_models.name, brands_models.model_file_id, IFNULL(documents_files.parent_hash, documents_files.hash) AS new_hash FROM documents_files LEFT JOIN documents ON documents.document_id = documents_files.document_id LEFT JOIN brands_models ON FIND_IN_SET(brands_models.model_id, models) LEFT JOIN brands ON (FIND_IN_SET(brands.brand_id, documents.brands)) WHERE documents.document_id IS NOT NULL AND documents.active_web = 'Y' AND documents.closed = 'Y' AND documents.active_web = 'Y' AND (IFNULL(documents.active_web_from, DATE(NOW())) <= DATE(NOW()) AND DATE(NOW()) <= IFNULL(documents.active_web_to, DATE(NOW()))) AND brands.brand_id = '33' AND (FIND_IN_SET(29, documents.file_category_id)) GROUP BY new_hash ORDER BY brands_models.ord ASC, documents.priority ASC, super_priority DESC, my_priority ASC, documents_files.priority ASC LIMIT 0, 99999

Query: SELECT documents_files.priority AS my_priority, MAX(documents_files.priority) AS super_priority, documents.document_id, documents.has_main_thumb, documents.hash_thumb, documents.title, documents.description_short, documents.description_long, documents.notes, documents.active_web_to, documents.created, documents.active_web_from, documents.file_category_id, brands_models.model_id, documents.models, documents.representatives, documents.car_services_options, documents_files.description, documents_files.hash, documents_files.url, documents_files.document_file_id, brands_models.name, brands_models.model_file_id, IFNULL(documents_files.parent_hash, documents_files.hash) AS new_hash FROM documents_files LEFT JOIN documents ON documents.document_id = documents_files.document_id LEFT JOIN brands_models ON FIND_IN_SET(brands_models.model_id, models) LEFT JOIN brands ON (FIND_IN_SET(brands.brand_id, documents.brands)) WHERE documents.document_id IS NOT NULL AND documents.active_web = 'Y' AND documents.closed = 'Y' AND documents.active_web = 'Y' AND (IFNULL(documents.active_web_from, DATE(NOW())) <= DATE(NOW()) AND DATE(NOW()) <= IFNULL(documents.active_web_to, DATE(NOW()))) AND brands.brand_id = '33' AND (FIND_IN_SET(30, documents.file_category_id)) GROUP BY new_hash ORDER BY brands_models.ord ASC, documents.priority ASC, super_priority DESC, my_priority ASC, documents_files.priority ASC LIMIT 0, 99999

Query: SELECT documents_files.priority AS my_priority, MAX(documents_files.priority) AS super_priority, documents.document_id, documents.has_main_thumb, documents.hash_thumb, documents.title, documents.description_short, documents.description_long, documents.notes, documents.active_web_to, documents.created, documents.active_web_from, documents.file_category_id, brands_models.model_id, documents.models, documents.representatives, documents.car_services_options, documents_files.description, documents_files.hash, documents_files.url, documents_files.document_file_id, brands_models.name, brands_models.model_file_id, IFNULL(documents_files.parent_hash, documents_files.hash) AS new_hash FROM documents_files LEFT JOIN documents ON documents.document_id = documents_files.document_id LEFT JOIN brands_models ON FIND_IN_SET(brands_models.model_id, models) LEFT JOIN brands ON (FIND_IN_SET(brands.brand_id, documents.brands)) WHERE documents.document_id IS NOT NULL AND documents.active_web = 'Y' AND documents.closed = 'Y' AND documents.active_web = 'Y' AND ( (documents_files.parent_hash IS NULL AND ((SELECT COUNT(*) AS count FROM documents_files df WHERE df.parent_hash = documents_files.hash LIMIT 0,1) = 0)) OR ((SELECT df.document_file_id FROM documents_files df WHERE df.parent_hash = documents_files.parent_hash ORDER BY priority DESC LIMIT 0,1) = documents_files.document_file_id) ) AND (IFNULL(documents.active_web_from, DATE(NOW())) <= DATE(NOW()) AND DATE(NOW()) <= IFNULL(documents.active_web_to, DATE(NOW()))) AND brands.brand_id = '33' AND (documents.representatives IS NULL OR FIND_IN_SET('454', documents.representatives)) AND (FIND_IN_SET(28, documents.file_category_id)) GROUP BY documents.document_id ORDER BY documents.priority ASC LIMIT 0, 99999

Domov - Volvo Car Slovenija - SUMMIT AVTO d.o.o.
SUMMIT AVTO d.o.o.
 

OBVEŠČAJTE ME O NOVOSTIH

Vaše ime

Query: SHOW FULL COLUMNS FROM `clients`

Query: SHOW FULL COLUMNS FROM `clients`

Query: SHOW FULL COLUMNS FROM `clients`

Vaš priimek

Query: SHOW FULL COLUMNS FROM `clients`

Query: SHOW FULL COLUMNS FROM `clients`

Vaš e-mail naslov

Query: SHOW FULL COLUMNS FROM `clients`

Query: SHOW FULL COLUMNS FROM `clients`

S prijavo na e-novice se strinjate s splošnimi pogoji.

Stopite v stik

SUMMIT AVTO d.o.o.
Flajšmanova ulica 3, 1000 Ljubljana

T: 01-2525-133 (Servis naročanje)

E: info@summitavto.si (Servis)
T: 01-2525-295 (Prodaja rezervnih delov in dodatne opreme)

Odpiralni čas

SERVIS

Pon - Pet:07:00 - 18:00
Sobota:09:00 - 13:00

 

Volvo in piškotki

S tehnologijo piškotkov (cookies) vam omogočamo kar najboljše doživetje naše spletne strani. Podatki pridobljeni preko piškotkov so anonimni. Prosimo označite ali se strinjate z uporabo te tehnologije. Več o piškotkih.

Sprejmem
Več informacij