Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /var/www/ecat.autodevel.com/opel/models/sdb/db/mysql.php on line 7
SELECT SQL_CACHE ID_grp, dic.Text as Name
FROM cat_groups grp
left join dictionary dic on grp.Key_dic = dic.Key and dic.lang = 'FR'
WHERE grp.ID_grp = 4255
ORDER BY Name
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/ecat.autodevel.com/opel/models/sdb/db/mysql.php on line 27
SELECT SQL_CACHE ID_grp, dic.Text as Name
FROM cat_groups grp
left join dictionary dic on grp.Key_dic = dic.Key and dic.lang = 'FR'
WHERE grp.ID_grp = 4255
ORDER BY Name
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/ecat.autodevel.com/opel/models/sdb/db/mysql.php on line 27
SELECT SQL_CACHE typ.ID_typ, dic.`text` as Name
FROM cat_types typ
left join dictionary dic on typ.Key_dic = dic.Key and dic.lang = 'FR'
WHERE ID_typ = 273
ORDER BY Name
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/ecat.autodevel.com/opel/models/sdb/db/mysql.php on line 27
select GROUP_CONCAT(DISTINCT sec.ID_sec ORDER BY CAST(sec.Code as SIGNED) SEPARATOR ',') as ID_sec
, GROUP_CONCAT(DISTINCT CONCAT('',sec.Code, ' ', REPLACE(dic.`text`,'"','')) ORDER BY CAST(sec.Code as SIGNED) SEPARATOR ' ') as Name
, GROUP_CONCAT(DISTINCT REPLACE(dic.`text`,'"','') ORDER BY CAST(sec.Code as SIGNED) SEPARATOR '\n') as Title
, REPLACE(sec.Description,'"','') as Description
, CONCAT(mfa.`Name`,'/', REPLACE( REPLACE(sec.Image,'.jpg', (case when sec.ID_cat in (3,4,5) then '.png' else '.gif' end) ), 'schema','previe') ) as Image
, MIN(CAST(sec.Code as SIGNED)) as Sort
from cat_sections sec
left join dictionary dic on sec.Key_dic = dic.Key and dic.lang = 'FR'
inner join cat_groups grp on sec.ID_grp = grp.ID_grp
inner join cat_types typ on grp.ID_typ = typ.ID_typ
inner join cat_models mdl on typ.ID_mod = mdl.ID_mod
inner join cat_manufacturers mfa on mdl.ID_mfa = mfa.ID_mfa
where sec.`ID_grp`= 4255
group by sec.Image, sec.Description
order by Sort
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/ecat.autodevel.com/opel/models/sdb/db/mysql.php on line 27
select SQL_CACHE null as ID_oem
, null as ID_art
, `sec`.ID_sec
, NULL as PNC
, sec.Code
, NULL as Article
, NULL as ArticleKat
, NULL as Quantity
, REPLACE(dics.`text`,'"','') as `Name`
, sec.Description
, CONCAT(mfa.`Name`,'/',sec.Image) as Image
, sec.Sort as SortSec
, -1 as SortArt
from cat_sections sec
left join dictionary dics on sec.Key_dic = dics.Key and dics.lang = 'FR'
inner join cat_groups grp on sec.ID_grp = grp.ID_grp
inner join cat_types typ on grp.ID_typ = typ.ID_typ
inner join cat_models mdl on typ.ID_mod = mdl.ID_mod
inner join cat_manufacturers mfa on mdl.ID_mfa = mfa.ID_mfa
where sec.ID_sec in (20669)
UNION
select art.ID_art as ID_oem
, art.ID_art
, lnk.ID_sec
, lnk.Code as `PNC`
, art.Article as `Code`
, art.ArticleKat
, art.Search as Article
, lnk.`Quantity`
, REPLACE(dica.`Text`,'"','') as `Name`
, dicl.`Text` as Description
, CONCAT(mfa.`Name`,'\\',sec.Image) as Image
, sec.Sort as SortSec
, IFNULL(lnk.Sort,1) as SortArt
from cat_articles_link lnk
left join dictionary dicl on lnk.Key_dic = dicl.Key and dicl.lang = 'FR'
inner join cat_articles art on lnk.ID_art = art.ID_art
left join dictionary dica on art.Key_dic = dica.Key and dica.lang = 'FR'
left join cat_sections sec on lnk.ID_sec = sec.Id_sec
inner join cat_groups grp on sec.ID_grp = grp.ID_grp
inner join cat_types typ on grp.ID_typ = typ.ID_typ
inner join cat_models mdl on typ.ID_mod = mdl.ID_mod
inner join cat_manufacturers mfa on mdl.ID_mfa = mfa.ID_mfa
left join cat_filters flt on lnk.ID_flt = flt.ID_flt
where lnk.ID_sec in (20669)
order by SortSec, ID_sec, SortArt, PNC
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/ecat.autodevel.com/opel/models/sdb/db/mysql.php on line 27
Notice: Undefined offset: 0 in /var/www/ecat.autodevel.com/opel/controllers/catalog.php on line 344
""
