"select count(*) as aggregate from `catalog_products` where `active` = ? and `language` = ?"

array:2 [
  0 => "active"
  1 => "ro"
]

2096.5

"select * from `cars` where `cars`.`active` = ? and `cars`.`language` = ? and `cars`.`type` = ? and `cars`.`deleted_at` is null order by `cars`.`title` asc"

array:3 [
  0 => "active"
  1 => "ro"
  2 => "motorcycle"
]

2.23

"select * from `cars` where `cars`.`active` = ? and `cars`.`language` = ? and `cars`.`type` = ? and `cars`.`deleted_at` is null order by `cars`.`title` asc"

array:3 [
  0 => "active"
  1 => "ro"
  2 => "motor"
]

2.07

Acasa
Despre noi

"select * from `catalog_products` where `catalog_products`.`catalog_id` = ? and `catalog_products`.`catalog_id` is not null"

array:1 [
  0 => 5
]

19.33

"select distinct `catalog_categories`.* from `catalog_categories` inner join `catalog_category_product` on `catalog_categories`.`id` = `catalog_category_product`.`category_id` and `catalog_categories`.`active` = ? inner join `catalog_products` on `catalog_products`.`id` = `catalog_category_product`.`product_id` and `catalog_products`.`active` = ? and `catalog_products`.`catalog_id` = ? order by `catalog_categories`.`position` asc"

array:3 [
  0 => "active"
  1 => "active"
  2 => 5
]

137.86

Uleiuri si lichide

"select * from `catalog_products` where `catalog_products`.`catalog_id` = ? and `catalog_products`.`catalog_id` is not null"

array:1 [
  0 => 15
]

2.62

"select distinct `catalog_categories`.* from `catalog_categories` inner join `catalog_category_product` on `catalog_categories`.`id` = `catalog_category_product`.`category_id` and `catalog_categories`.`active` = ? inner join `catalog_products` on `catalog_products`.`id` = `catalog_category_product`.`product_id` and `catalog_products`.`active` = ? and `catalog_products`.`catalog_id` = ? order by `catalog_categories`.`position` asc"

array:3 [
  0 => "active"
  1 => "active"
  2 => 15
]

6.45

Baterii auto

"select * from `catalog_products` where `catalog_products`.`catalog_id` = ? and `catalog_products`.`catalog_id` is not null"

array:1 [
  0 => 16
]

7.94

"select distinct `catalog_categories`.* from `catalog_categories` inner join `catalog_category_product` on `catalog_categories`.`id` = `catalog_category_product`.`category_id` and `catalog_categories`.`active` = ? inner join `catalog_products` on `catalog_products`.`id` = `catalog_category_product`.`product_id` and `catalog_products`.`active` = ? and `catalog_products`.`catalog_id` = ? order by `catalog_categories`.`position` asc"

array:3 [
  0 => "active"
  1 => "active"
  2 => 16
]

51.63

Lamela stergator

"select * from `catalog_products` where `catalog_products`.`catalog_id` = ? and `catalog_products`.`catalog_id` is not null"

array:1 [
  0 => 19
]

2.44

"select distinct `catalog_categories`.* from `catalog_categories` inner join `catalog_category_product` on `catalog_categories`.`id` = `catalog_category_product`.`category_id` and `catalog_categories`.`active` = ? inner join `catalog_products` on `catalog_products`.`id` = `catalog_category_product`.`product_id` and `catalog_products`.`active` = ? and `catalog_products`.`catalog_id` = ? order by `catalog_categories`.`position` asc"

array:3 [
  0 => "active"
  1 => "active"
  2 => 19
]

6.39

Racord flexibil esapament

"select * from `catalog_products` where `catalog_products`.`catalog_id` = ? and `catalog_products`.`catalog_id` is not null"

array:1 [
  0 => 11
]

2.02

"select distinct `catalog_categories`.* from `catalog_categories` inner join `catalog_category_product` on `catalog_categories`.`id` = `catalog_category_product`.`category_id` and `catalog_categories`.`active` = ? inner join `catalog_products` on `catalog_products`.`id` = `catalog_category_product`.`product_id` and `catalog_products`.`active` = ? and `catalog_products`.`catalog_id` = ? order by `catalog_categories`.`position` asc"

array:3 [
  0 => "active"
  1 => "active"
  2 => 11
]

2.74

Siguranta auto

"select distinct `catalog_categories`.* from `catalog_categories` inner join `catalog_category_product` on `catalog_categories`.`id` = `catalog_category_product`.`category_id` and `catalog_categories`.`active` = ? inner join `catalog_products` on `catalog_products`.`id` = `catalog_category_product`.`product_id` and `catalog_products`.`active` = ? and `catalog_products`.`catalog_id` = ? order by `catalog_categories`.`position` asc"

array:3 [
  0 => "active"
  1 => "active"
  2 => 10
]

3.85

Intretinere auto

"select * from `catalog_products` where `catalog_products`.`catalog_id` = ? and `catalog_products`.`catalog_id` is not null"

array:1 [
  0 => 12
]

11.29

"select distinct `catalog_categories`.* from `catalog_categories` inner join `catalog_category_product` on `catalog_categories`.`id` = `catalog_category_product`.`category_id` and `catalog_categories`.`active` = ? inner join `catalog_products` on `catalog_products`.`id` = `catalog_category_product`.`product_id` and `catalog_products`.`active` = ? and `catalog_products`.`catalog_id` = ? order by `catalog_categories`.`position` asc"

array:3 [
  0 => "active"
  1 => "active"
  2 => 12
]

53.5

Accesorii auto

"select * from `catalog_products` where `catalog_products`.`catalog_id` = ? and `catalog_products`.`catalog_id` is not null"

array:1 [
  0 => 17
]

2.9

"select distinct `catalog_categories`.* from `catalog_categories` inner join `catalog_category_product` on `catalog_categories`.`id` = `catalog_category_product`.`category_id` and `catalog_categories`.`active` = ? inner join `catalog_products` on `catalog_products`.`id` = `catalog_category_product`.`product_id` and `catalog_products`.`active` = ? and `catalog_products`.`catalog_id` = ? order by `catalog_categories`.`position` asc"

array:3 [
  0 => "active"
  1 => "active"
  2 => 17
]

7.21

Cruci cardanice

"select * from `catalog_products` where `catalog_products`.`catalog_id` = ? and `catalog_products`.`catalog_id` is not null"

array:1 [
  0 => 18
]

4.08

"select distinct `catalog_categories`.* from `catalog_categories` inner join `catalog_category_product` on `catalog_categories`.`id` = `catalog_category_product`.`category_id` and `catalog_categories`.`active` = ? inner join `catalog_products` on `catalog_products`.`id` = `catalog_category_product`.`product_id` and `catalog_products`.`active` = ? and `catalog_products`.`catalog_id` = ? order by `catalog_categories`.`position` asc"

array:3 [
  0 => "active"
  1 => "active"
  2 => 18
]

49.35

Becuri auto

"select distinct `catalog_categories`.* from `catalog_categories` inner join `catalog_category_product` on `catalog_categories`.`id` = `catalog_category_product`.`category_id` and `catalog_categories`.`active` = ? inner join `catalog_products` on `catalog_products`.`id` = `catalog_category_product`.`product_id` and `catalog_products`.`active` = ? and `catalog_products`.`catalog_id` = ? order by `catalog_categories`.`position` asc"

array:3 [
  0 => "active"
  1 => "active"
  2 => 13
]

2.95

Vopsele si accesorii

"select distinct `catalog_categories`.* from `catalog_categories` inner join `catalog_category_product` on `catalog_categories`.`id` = `catalog_category_product`.`category_id` and `catalog_categories`.`active` = ? inner join `catalog_products` on `catalog_products`.`id` = `catalog_category_product`.`product_id` and `catalog_products`.`active` = ? and `catalog_products`.`catalog_id` = ? order by `catalog_categories`.`position` asc"

array:3 [
  0 => "active"
  1 => "active"
  2 => 14
]

2.93

Furtun combustibil

"select * from `catalog_products` where `catalog_products`.`catalog_id` = ? and `catalog_products`.`catalog_id` is not null"

array:1 [
  0 => 21
]

5.81

"select distinct `catalog_categories`.* from `catalog_categories` inner join `catalog_category_product` on `catalog_categories`.`id` = `catalog_category_product`.`category_id` and `catalog_categories`.`active` = ? inner join `catalog_products` on `catalog_products`.`id` = `catalog_category_product`.`product_id` and `catalog_products`.`active` = ? and `catalog_products`.`catalog_id` = ? order by `catalog_categories`.`position` asc"

array:3 [
  0 => "active"
  1 => "active"
  2 => 21
]

51.57

Scule de mana

"select * from `parts_categories` where `active` = ? and `parent` = ? and `parts_categories`.`deleted_at` is null order by `title` asc"

array:2 [
  0 => "active"
  1 => 0
]

3.48

"select * from `parts_categories` where `active` = ? and `parts_categories`.`deleted_at` is null order by `position` asc"

array:1 [
  0 => "active"
]

24.99

Categorii piese auto
Marci masini
Blog
Contact

0770 859 562 | office@sewa-pieseauto.ro

Inregistrare | Autentificare

Cosul meu 0.00 RON

"select * from `cars` where `active` = ? and `type` = ? and `cars`.`deleted_at` is null order by `title` asc"

array:2 [
  0 => "active"
  1 => "car"
]

2.83

"select * from `cars` where `active` = ? and `type` = ? and `cars`.`deleted_at` is null order by `title` asc"

array:2 [
  0 => "active"
  1 => "commercial"
]

2.3

"select * from `product_images` where `product_images`.`product_id` = ? and `product_images`.`product_id` is not null"

array:1 [
  0 => 28753
]

5.29

Ulei de motor RWJ SEMISYNT. 10W40 4L SET

Disponibilitate: In stoc

Solicita oferta

"select * from `settings_scripts` where `active` = ? and `type` = ?"

array:2 [
  0 => "active"
  1 => "header"
]

59.55

Standard: MB 229.1 ; VW 505.00

Destinat pentru: Turisme

Cantitate: 3 x 4L; 2 x 0.5L

"select `title`, `position`, `catalog_attribute_product`.* from `catalog_attributes` inner join `catalog_attribute_product` on `catalog_attribute_product`.`attribute_id` = `catalog_attributes`.`id` and `catalog_attribute_product`.`product_id` = ? where `catalog_attributes`.`active` = ? order by `position` asc"

array:2 [
  0 => 28753
  1 => "active"
]

2.19

Capacitate	4 L
Norma de calitate SAE	10W40
Specificatie ACEA	A3; B3; B4
Specificatie API	CF; SJ; SL

Retur gratuit

Retur gratuit al produselor 14 zile!
Livrare gratuita

Pentru comenzi mai mari de 500 de lei si sub 5 kg!
Plati sigure

Plati sigure cu cardul prin MobilPay!
Discounturi zilnice

Oferim discounturi zilnice la sute de produse!

Ulei de motor RWJ SEMISYNT. 10W40 4L SET

Retur gratuit

Livrare gratuita

Plati sigure

Discounturi zilnice

Alte informatii

Informatii clienti

Cine suntem

Ulei de motor RWJ SEMISYNT. 10W40 4L SET

Retur gratuit

Livrare gratuita

Plati sigure

Discounturi zilnice

Aboneaza-te la newsletter